Expresso Churn Dataset Report

Brought to you by YData

Dataset statistics

Number of variables	17
Number of observations	511457
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	70.2 MiB
Average record size in memory	144.0 B

Variable types

Numeric	11
Categorical	6

Alerts

`ON_NET` has constant value "27.0"	Constant
`ORANGE` has constant value "29.0"	Constant
`TIGO` has constant value "6.0"	Constant
`MRG` has constant value "0"	Constant
`FREQ_TOP_PACK` has constant value "5.0"	Constant
`ARPU_SEGMENT` is highly overall correlated with `FREQUENCE` and 1 other fields	High correlation
`FREQUENCE` is highly overall correlated with `ARPU_SEGMENT` and 1 other fields	High correlation
`FREQUENCE_RECH` is highly overall correlated with `MONTANT`	High correlation
`MONTANT` is highly overall correlated with `FREQUENCE_RECH`	High correlation
`REVENUE` is highly overall correlated with `ARPU_SEGMENT` and 1 other fields	High correlation
`TOP_PACK` is highly skewed (γ1 = 73.61180278)	Skewed
`user_id` has unique values	Unique
`REGION` has 464072 (90.7%) zeros	Zeros

Reproduction

Analysis started	2025-07-28 11:56:30.791118
Analysis finished	2025-07-28 11:57:03.655953
Duration	32.86 seconds
Software version	ydata-profiling vv4.16.1
Download configuration	config.json

user_id
Real number (ℝ)

Unique

Distinct	511457
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1075925

Minimum	1
Maximum	2154045
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.8 MiB

Quantile statistics

Minimum	1
5-th percentile	107304.8
Q1	538252
median	1074663
Q3	1613435
95-th percentile	2045543.2
Maximum	2154045
Range	2154044
Interquartile range (IQR)	1075183

Descriptive statistics

Standard deviation	621569.56
Coefficient of variation (CV)	0.57770713
Kurtosis	-1.198197
Mean	1075925
Median Absolute Deviation (MAD)	537594
Skewness	0.0015387196
Sum	5.5028939 × 10¹¹
Variance	3.8634871 × 10¹¹
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2154045	1	< 0.1%
2154002	1	< 0.1%
2153996	1	< 0.1%
2153994	1	< 0.1%
2153990	1	< 0.1%
2153987	1	< 0.1%
2153982	1	< 0.1%
2153980	1	< 0.1%
2153974	1	< 0.1%
2153970	1	< 0.1%
Other values (511447)	511447	> 99.9%

Value	Count	Frequency (%)
1	1	< 0.1%
6	1	< 0.1%
10	1	< 0.1%
12	1	< 0.1%
17	1	< 0.1%
20	1	< 0.1%
22	1	< 0.1%
35	1	< 0.1%
46	1	< 0.1%
51	1	< 0.1%

Value	Count	Frequency (%)
2154045	1	< 0.1%
2154043	1	< 0.1%
2154041	1	< 0.1%
2154034	1	< 0.1%
2154033	1	< 0.1%
2154032	1	< 0.1%
2154029	1	< 0.1%
2154028	1	< 0.1%
2154027	1	< 0.1%
2154024	1	< 0.1%

REGION
Real number (ℝ)

Zeros

Distinct	14
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.68073758

Minimum	0
Maximum	13
Zeros	464072
Zeros (%)	90.7%
Negative	0
Negative (%)	0.0%
Memory size	7.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	7
Maximum	13
Range	13
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	2.4493177
Coefficient of variation (CV)	3.5980351
Kurtosis	13.154023
Mean	0.68073758
Median Absolute Deviation (MAD)	0
Skewness	3.7606817
Sum	348168
Variance	5.9991572
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=14)

Value	Count	Frequency (%)
0	464072	90.7%
12	10593	2.1%
4	6759	1.3%
9	6105	1.2%
1	5597	1.1%
7	5407	1.1%
11	2730	0.5%
3	2055	0.4%
6	1971	0.4%
2	1934	0.4%
Other values (4)	4234	0.8%

Value	Count	Frequency (%)
0	464072	90.7%
1	5597	1.1%
2	1934	0.4%
3	2055	0.4%
4	6759	1.3%
5	121	< 0.1%
6	1971	0.4%
7	5407	1.1%
8	1887	0.4%
9	6105	1.2%

Value	Count	Frequency (%)
13	1925	0.4%
12	10593	2.1%
11	2730	0.5%
10	301	0.1%
9	6105	1.2%
8	1887	0.4%
7	5407	1.1%
6	1971	0.4%
5	121	< 0.1%
4	6759	1.3%

TENURE
Real number (ℝ)

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.8109538

Minimum	0
Maximum	7
Zeros	65
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	7.8 MiB

Quantile statistics

Minimum	0
5-th percentile	5
Q1	7
median	7
Q3	7
95-th percentile	7
Maximum	7
Range	7
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.75022196
Coefficient of variation (CV)	0.11014932
Kurtosis	19.616014
Mean	6.8109538
Median Absolute Deviation (MAD)	0
Skewness	-4.3517824
Sum	3483510
Variance	0.562833
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
7	475499	93.0%
5	15063	2.9%
4	8671	1.7%
3	5456	1.1%
6	3874	0.8%
2	2577	0.5%
1	252	< 0.1%
0	65	< 0.1%

Value	Count	Frequency (%)
0	65	< 0.1%
1	252	< 0.1%
2	2577	0.5%
3	5456	1.1%
4	8671	1.7%
5	15063	2.9%
6	3874	0.8%
7	475499	93.0%

Value	Count	Frequency (%)
7	475499	93.0%
6	3874	0.8%
5	15063	2.9%
4	8671	1.7%
3	5456	1.1%
2	2577	0.5%
1	252	< 0.1%
0	65	< 0.1%

MONTANT
Real number (ℝ)

High correlation

Distinct	113
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2892.0844

Minimum	20
Maximum	8100
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.8 MiB

Quantile statistics

Minimum	20
5-th percentile	3000
Q1	3000
median	3000
Q3	3000
95-th percentile	3000
Maximum	8100
Range	8080
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	530.88017
Coefficient of variation (CV)	0.18356316
Kurtosis	20.092572
Mean	2892.0844
Median Absolute Deviation (MAD)	0
Skewness	-4.5812686
Sum	1.4791768 × 10⁹
Variance	281833.76
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3000	490071	95.8%
200	5912	1.2%
500	5801	1.1%
100	4057	0.8%
250	1284	0.3%
1000	1209	0.2%
300	913	0.2%
400	327	0.1%
150	315	0.1%
600	306	0.1%
Other values (103)	1262	0.2%

Value	Count	Frequency (%)
20	1	< 0.1%
30	2	< 0.1%
50	108	< 0.1%
100	4057	0.8%
125	1	< 0.1%
130	1	< 0.1%
150	315	0.1%
195	1	< 0.1%
200	5912	1.2%
210	1	< 0.1%

Value	Count	Frequency (%)
8100	1	< 0.1%
8000	1	< 0.1%
7750	1	< 0.1%
7700	1	< 0.1%
7500	3	< 0.1%
7200	1	< 0.1%
7000	2	< 0.1%
6850	2	< 0.1%
6600	1	< 0.1%
6000	3	< 0.1%

FREQUENCE_RECH
Real number (ℝ)

High correlation

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.7524269

Minimum	1
Maximum	9
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.8 MiB

Quantile statistics

Minimum	1
5-th percentile	7
Q1	7
median	7
Q3	7
95-th percentile	7
Maximum	9
Range	8
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.1867503
Coefficient of variation (CV)	0.17575168
Kurtosis	19.186098
Mean	6.7524269
Median Absolute Deviation (MAD)	0
Skewness	-4.5977819
Sum	3453576
Variance	1.4083764
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
7	490023	95.8%
1	19982	3.9%
2	1150	0.2%
3	176	< 0.1%
4	63	< 0.1%
5	38	< 0.1%
6	20	< 0.1%
9	3	< 0.1%
8	2	< 0.1%

Value	Count	Frequency (%)
1	19982	3.9%
2	1150	0.2%
3	176	< 0.1%
4	63	< 0.1%
5	38	< 0.1%
6	20	< 0.1%
7	490023	95.8%
8	2	< 0.1%
9	3	< 0.1%

Value	Count	Frequency (%)
9	3	< 0.1%
8	2	< 0.1%
7	490023	95.8%
6	20	< 0.1%
5	38	< 0.1%
4	63	< 0.1%
3	176	< 0.1%
2	1150	0.2%
1	19982	3.9%

REVENUE
Real number (ℝ)

High correlation

Distinct	842
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2866.2131

Minimum	1
Maximum	5680
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.8 MiB

Quantile statistics

Minimum	1
5-th percentile	3000
Q1	3000
median	3000
Q3	3000
95-th percentile	3000
Maximum	5680
Range	5679
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	611.69683
Coefficient of variation (CV)	0.21341638
Kurtosis	17.030692
Mean	2866.2131
Median Absolute Deviation (MAD)	0
Skewness	-4.3474669
Sum	1.4659448 × 10⁹
Variance	374173.01
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3000	487778	95.4%
1	1989	0.4%
20	1434	0.3%
2	1363	0.3%
4	1105	0.2%
10	1096	0.2%
100	885	0.2%
11	755	0.1%
200	740	0.1%
8	706	0.1%
Other values (832)	13606	2.7%

Value	Count	Frequency (%)
1	1989	0.4%
2	1363	0.3%
3	27	< 0.1%
4	1105	0.2%
5	27	< 0.1%
6	611	0.1%
7	338	0.1%
8	706	0.1%
9	664	0.1%
10	1096	0.2%

Value	Count	Frequency (%)
5680	1	< 0.1%
5649	1	< 0.1%
5502	1	< 0.1%
5498	1	< 0.1%
5410	1	< 0.1%
5399	1	< 0.1%
5350	6	< 0.1%
5338	1	< 0.1%
5300	9	< 0.1%
5279	1	< 0.1%

ARPU_SEGMENT
Real number (ℝ)

High correlation

Distinct	463
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	955.40397

Minimum	0
Maximum	1893
Zeros	1989
Zeros (%)	0.4%
Negative	0
Negative (%)	0.0%
Memory size	7.8 MiB

Quantile statistics

Minimum	0
5-th percentile	1000
Q1	1000
median	1000
Q3	1000
95-th percentile	1000
Maximum	1893
Range	1893
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	203.90096
Coefficient of variation (CV)	0.21341858
Kurtosis	17.030819
Mean	955.40397
Median Absolute Deviation (MAD)	0
Skewness	-4.3474771
Sum	4.8864805 × 10⁸
Variance	41575.602
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1000	487781	95.4%
1	2495	0.5%
3	2466	0.5%
0	1989	0.4%
7	1830	0.4%
4	1593	0.3%
5	1138	0.2%
33	1001	0.2%
2	976	0.2%
67	797	0.2%
Other values (453)	9391	1.8%

Value	Count	Frequency (%)
0	1989	0.4%
1	2495	0.5%
2	976	0.2%
3	2466	0.5%
4	1593	0.3%
5	1138	0.2%
6	706	0.1%
7	1830	0.4%
8	382	0.1%
9	616	0.1%

Value	Count	Frequency (%)
1893	1	< 0.1%
1883	1	< 0.1%
1834	1	< 0.1%
1833	1	< 0.1%
1803	1	< 0.1%
1800	1	< 0.1%
1783	6	< 0.1%
1779	1	< 0.1%
1767	9	< 0.1%
1760	1	< 0.1%

FREQUENCE
Real number (ℝ)

High correlation

Distinct	16
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8.6525417

Minimum	1
Maximum	16
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.8 MiB

Quantile statistics

Minimum	1
5-th percentile	9
Q1	9
median	9
Q3	9
95-th percentile	9
Maximum	16
Range	15
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.6030191
Coefficient of variation (CV)	0.18526568
Kurtosis	17.728371
Mean	8.6525417
Median Absolute Deviation (MAD)	0
Skewness	-4.4195104
Sum	4425403
Variance	2.5696701
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=16)

Value	Count	Frequency (%)
9	487820	95.4%
1	18197	3.6%
2	3227	0.6%
3	907	0.2%
4	520	0.1%
5	298	0.1%
6	129	< 0.1%
10	125	< 0.1%
7	113	< 0.1%
8	59	< 0.1%
Other values (6)	62	< 0.1%

Value	Count	Frequency (%)
1	18197	3.6%
2	3227	0.6%
3	907	0.2%
4	520	0.1%
5	298	0.1%
6	129	< 0.1%
7	113	< 0.1%
8	59	< 0.1%
9	487820	95.4%
10	125	< 0.1%

Value	Count	Frequency (%)
16	7	< 0.1%
15	6	< 0.1%
14	6	< 0.1%
13	8	< 0.1%
12	19	< 0.1%
11	16	< 0.1%
10	125	< 0.1%
9	487820	95.4%
8	59	< 0.1%
7	113	< 0.1%

DATA_VOLUME
Real number (ℝ)

Distinct	161
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	256.88412

Minimum	157
Maximum	317
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.8 MiB

Quantile statistics

Minimum	157
5-th percentile	257
Q1	257
median	257
Q3	257
95-th percentile	257
Maximum	317
Range	160
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	3.5054862
Coefficient of variation (CV)	0.013646177
Kurtosis	463.20091
Mean	256.88412
Median Absolute Deviation (MAD)	0
Skewness	-17.434749
Sum	1.3138518 × 10⁸
Variance	12.288434
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
257	509358	99.6%
159	25	< 0.1%
172	23	< 0.1%
168	23	< 0.1%
310	23	< 0.1%
192	22	< 0.1%
187	21	< 0.1%
160	21	< 0.1%
209	21	< 0.1%
190	21	< 0.1%
Other values (151)	1899	0.4%

Value	Count	Frequency (%)
157	11	< 0.1%
158	18	< 0.1%
159	25	< 0.1%
160	21	< 0.1%
161	15	< 0.1%
162	17	< 0.1%
163	20	< 0.1%
164	17	< 0.1%
165	11	< 0.1%
166	19	< 0.1%

Value	Count	Frequency (%)
317	9	< 0.1%
316	12	< 0.1%
315	8	< 0.1%
314	16	< 0.1%
313	6	< 0.1%
312	7	< 0.1%
311	11	< 0.1%
310	23	< 0.1%
309	10	< 0.1%
308	17	< 0.1%

ON_NET
Categorical

Constant

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.8 MiB

27.0	511457

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	2045828
Distinct characters	4
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	27.0
2nd row	27.0
3rd row	27.0
4th row	27.0
5th row	27.0

Common Values

Value	Count	Frequency (%)
27.0	511457	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
27.0	511457	100.0%

Most occurring characters

Value	Count	Frequency (%)
2	511457	25.0%
7	511457	25.0%
.	511457	25.0%
0	511457	25.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1534371	75.0%
Other Punctuation	511457	25.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	511457	33.3%
7	511457	33.3%
0	511457	33.3%

Other Punctuation

Value	Count	Frequency (%)
.	511457	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2045828	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	511457	25.0%
7	511457	25.0%
.	511457	25.0%
0	511457	25.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2045828	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	511457	25.0%
7	511457	25.0%
.	511457	25.0%
0	511457	25.0%

ORANGE
Categorical

Constant

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.8 MiB

29.0	511457

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	2045828
Distinct characters	4
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	29.0
2nd row	29.0
3rd row	29.0
4th row	29.0
5th row	29.0

Common Values

Value	Count	Frequency (%)
29.0	511457	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
29.0	511457	100.0%

Most occurring characters

Value	Count	Frequency (%)
2	511457	25.0%
9	511457	25.0%
.	511457	25.0%
0	511457	25.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1534371	75.0%
Other Punctuation	511457	25.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	511457	33.3%
9	511457	33.3%
0	511457	33.3%

Other Punctuation

Value	Count	Frequency (%)
.	511457	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2045828	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	511457	25.0%
9	511457	25.0%
.	511457	25.0%
0	511457	25.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2045828	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	511457	25.0%
9	511457	25.0%
.	511457	25.0%
0	511457	25.0%

TIGO
Categorical

Constant

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.8 MiB

6.0	511457

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	1534371
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	6.0
2nd row	6.0
3rd row	6.0
4th row	6.0
5th row	6.0

Common Values

Value	Count	Frequency (%)
6.0	511457	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
6.0	511457	100.0%

Most occurring characters

Value	Count	Frequency (%)
6	511457	33.3%
.	511457	33.3%
0	511457	33.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1022914	66.7%
Other Punctuation	511457	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
6	511457	50.0%
0	511457	50.0%

Other Punctuation

Value	Count	Frequency (%)
.	511457	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1534371	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
6	511457	33.3%
.	511457	33.3%
0	511457	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1534371	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
6	511457	33.3%
.	511457	33.3%
0	511457	33.3%

MRG
Categorical

Constant

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.8 MiB

0	511457

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	511457
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	511457	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	511457	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	511457	100.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	511457	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	511457	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	511457	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	511457	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	511457	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	511457	100.0%

REGULARITY
Real number (ℝ)

Distinct	16
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.8260851

Minimum	1
Maximum	16
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.8 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	2
Q3	5
95-th percentile	12
Maximum	16
Range	15
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	3.5348028
Coefficient of variation (CV)	0.92386937
Kurtosis	1.7636715
Mean	3.8260851
Median Absolute Deviation (MAD)	1
Skewness	1.5451319
Sum	1956878
Variance	12.494831
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=16)

Value	Count	Frequency (%)
1	169305	33.1%
2	92381	18.1%
3	59041	11.5%
4	41646	8.1%
5	30946	6.1%
6	23814	4.7%
7	18788	3.7%
8	15156	3.0%
9	12297	2.4%
10	10327	2.0%
Other values (6)	37756	7.4%

Value	Count	Frequency (%)
1	169305	33.1%
2	92381	18.1%
3	59041	11.5%
4	41646	8.1%
5	30946	6.1%
6	23814	4.7%
7	18788	3.7%
8	15156	3.0%
9	12297	2.4%
10	10327	2.0%

Value	Count	Frequency (%)
16	4387	0.9%
15	4971	1.0%
14	5707	1.1%
13	6523	1.3%
12	7481	1.5%
11	8687	1.7%
10	10327	2.0%
9	12297	2.4%
8	15156	3.0%
7	18788	3.7%

TOP_PACK
Real number (ℝ)

Skewed

Distinct	13
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	18.020148

Minimum	18
Maximum	132
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.8 MiB

Quantile statistics

Minimum	18
5-th percentile	18
Q1	18
median	18
Q3	18
95-th percentile	18
Maximum	132
Range	114
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.3907251
Coefficient of variation (CV)	0.077176118
Kurtosis	5511.7071
Mean	18.020148
Median Absolute Deviation (MAD)	0
Skewness	73.611803
Sum	9216531
Variance	1.9341163
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=13)

Value	Count	Frequency (%)
18	511311	> 99.9%
123	59	< 0.1%
30	37	< 0.1%
126	18	< 0.1%
77	13	< 0.1%
31	6	< 0.1%
125	4	< 0.1%
40	3	< 0.1%
44	2	< 0.1%
93	1	< 0.1%
Other values (3)	3	< 0.1%

Value	Count	Frequency (%)
18	511311	> 99.9%
30	37	< 0.1%
31	6	< 0.1%
40	3	< 0.1%
44	2	< 0.1%
77	13	< 0.1%
82	1	< 0.1%
93	1	< 0.1%
96	1	< 0.1%
123	59	< 0.1%

Value	Count	Frequency (%)
132	1	< 0.1%
126	18	< 0.1%
125	4	< 0.1%
123	59	< 0.1%
96	1	< 0.1%
93	1	< 0.1%
82	1	< 0.1%
77	13	< 0.1%
44	2	< 0.1%
40	3	< 0.1%

FREQ_TOP_PACK
Categorical

Constant

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.8 MiB

5.0	511457

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	1534371
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	5.0
2nd row	5.0
3rd row	5.0
4th row	5.0
5th row	5.0

Common Values

Value	Count	Frequency (%)
5.0	511457	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
5.0	511457	100.0%

Most occurring characters

Value	Count	Frequency (%)
5	511457	33.3%
.	511457	33.3%
0	511457	33.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1022914	66.7%
Other Punctuation	511457	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
5	511457	50.0%
0	511457	50.0%

Other Punctuation

Value	Count	Frequency (%)
.	511457	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1534371	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
5	511457	33.3%
.	511457	33.3%
0	511457	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1534371	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
5	511457	33.3%
.	511457	33.3%
0	511457	33.3%

CHURN
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.8 MiB

1	285307
0	226150

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	511457
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	0
3rd row	0
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	285307	55.8%
0	226150	44.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	285307	55.8%
0	226150	44.2%

Most occurring characters

Value	Count	Frequency (%)
1	285307	55.8%
0	226150	44.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	511457	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	285307	55.8%
0	226150	44.2%

Most occurring scripts

Value	Count	Frequency (%)
Common	511457	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	285307	55.8%
0	226150	44.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	511457	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	285307	55.8%
0	226150	44.2%

	ARPU_SEGMENT	CHURN	DATA_VOLUME	FREQUENCE	FREQUENCE_RECH	MONTANT	REGION	REGULARITY	REVENUE	TENURE	TOP_PACK	user_id
ARPU_SEGMENT	1.000	0.044	0.004	0.977	0.179	0.177	0.019	-0.066	1.000	-0.005	-0.070	-0.002
CHURN	0.044	1.000	0.031	0.046	0.059	0.058	0.258	0.335	0.044	0.045	0.011	0.001
DATA_VOLUME	0.004	0.031	1.000	0.005	0.007	0.006	-0.010	-0.014	0.004	-0.004	-0.020	0.001
FREQUENCE	0.977	0.046	0.005	1.000	0.177	0.167	0.019	-0.062	0.977	-0.005	-0.068	-0.002
FREQUENCE_RECH	0.179	0.059	0.007	0.177	1.000	0.976	-0.013	0.002	0.179	-0.004	-0.065	0.002
MONTANT	0.177	0.058	0.006	0.167	0.976	1.000	-0.009	0.003	0.177	-0.003	-0.065	0.002
REGION	0.019	0.258	-0.010	0.019	-0.013	-0.009	1.000	0.125	0.019	0.017	0.006	-0.000
REGULARITY	-0.066	0.335	-0.014	-0.062	0.002	0.003	0.125	1.000	-0.066	0.033	0.019	0.002
REVENUE	1.000	0.044	0.004	0.977	0.179	0.177	0.019	-0.066	1.000	-0.005	-0.070	-0.002
TENURE	-0.005	0.045	-0.004	-0.005	-0.004	-0.003	0.017	0.033	-0.005	1.000	0.002	0.002
TOP_PACK	-0.070	0.011	-0.020	-0.068	-0.065	-0.065	0.006	0.019	-0.070	0.002	1.000	-0.001
user_id	-0.002	0.001	0.001	-0.002	0.002	0.002	-0.000	0.002	-0.002	0.002	-0.001	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

	user_id	REGION	TENURE	MONTANT	FREQUENCE_RECH	REVENUE	ARPU_SEGMENT	FREQUENCE	DATA_VOLUME	ON_NET	ORANGE	TIGO	REGULARITY	TOP_PACK	FREQ_TOP_PACK	CHURN
1	1	0	5	3000.0	7.0	3000.0	1000.0	9.0	257.0	27.0	29.0	6.0	4	18	5.0	1
6	6	7	7	3000.0	7.0	3000.0	1000.0	9.0	257.0	27.0	29.0	6.0	2	18	5.0	0
10	10	0	7	200.0	1.0	3000.0	1000.0	9.0	257.0	27.0	29.0	6.0	1	18	5.0	0
12	12	0	3	3000.0	7.0	3000.0	1000.0	9.0	257.0	27.0	29.0	6.0	2	18	5.0	1
17	17	0	4	3000.0	7.0	3000.0	1000.0	9.0	257.0	27.0	29.0	6.0	5	18	5.0	1
20	20	0	7	200.0	1.0	3000.0	1000.0	9.0	257.0	27.0	29.0	6.0	12	18	5.0	0
22	22	0	7	3000.0	7.0	3000.0	1000.0	9.0	257.0	27.0	29.0	6.0	4	18	5.0	1
35	35	0	7	3000.0	7.0	3000.0	1000.0	9.0	257.0	27.0	29.0	6.0	5	18	5.0	1
46	46	0	7	3000.0	7.0	3000.0	1000.0	9.0	257.0	27.0	29.0	6.0	8	18	5.0	0
51	51	0	7	3000.0	7.0	3000.0	1000.0	9.0	257.0	27.0	29.0	6.0	3	18	5.0	1

	user_id	REGION	TENURE	MONTANT	FREQUENCE_RECH	REVENUE	ARPU_SEGMENT	FREQUENCE	DATA_VOLUME	ON_NET	ORANGE	TIGO	REGULARITY	TOP_PACK	FREQ_TOP_PACK	CHURN
2154024	2154024	0	7	3000.0	7.0	3000.0	1000.0	9.0	257.0	27.0	29.0	6.0	2	18	5.0	0
2154027	2154027	12	7	3000.0	7.0	3000.0	1000.0	9.0	257.0	27.0	29.0	6.0	1	18	5.0	1
2154028	2154028	0	7	3000.0	7.0	3000.0	1000.0	9.0	257.0	27.0	29.0	6.0	8	18	5.0	0
2154029	2154029	0	7	3000.0	7.0	3000.0	1000.0	9.0	257.0	27.0	29.0	6.0	2	18	5.0	1
2154032	2154032	0	7	3000.0	7.0	3000.0	1000.0	9.0	257.0	27.0	29.0	6.0	1	18	5.0	0
2154033	2154033	0	7	3000.0	7.0	3000.0	1000.0	9.0	257.0	27.0	29.0	6.0	6	18	5.0	1
2154034	2154034	0	4	3000.0	7.0	3000.0	1000.0	9.0	257.0	27.0	29.0	6.0	4	18	5.0	1
2154041	2154041	0	7	3000.0	7.0	3000.0	1000.0	9.0	257.0	27.0	29.0	6.0	1	18	5.0	0
2154043	2154043	0	7	3000.0	7.0	3000.0	1000.0	9.0	257.0	27.0	29.0	6.0	6	18	5.0	0
2154045	2154045	0	7	3000.0	7.0	3000.0	1000.0	9.0	257.0	27.0	29.0	6.0	1	18	5.0	1

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script